package com.ccp.dev.qbdms.dao;

import com.ccp.dev.core.basic.base.IBaseMapper;
import com.ccp.dev.qbdms.model.WQbdFlightTest;
import com.ccp.dev.qbdms.model.WQbdQualitymanage;

import java.math.BigDecimal;
import java.util.Map;
import org.apache.ibatis.annotations.Mapper;
import com.ccp.dev.core.basic.web.query.QueryFilter;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 飞行试验管理 信息数据库操作类
 *
 * @author hjx
 * @date 2020-05-07 15:28:26
 */
@Mapper
public interface WQbdFlightTestDao extends IBaseMapper<WQbdFlightTest, String> {

	List<WQbdFlightTest> queryAll(QueryFilter queryFilter);

	/**
	 * 流程审批页面查询通过的数据
	 */
	List<WQbdFlightTest> reportList(@Param("dataId") String dataId,
			@Param("tableName") String tableName);

	/**
	 * 靶场零故障中汇总表
	 *
	 * @param paramMap 参数
	 */
	List<Map<String, Object>> getZeroFailureByGroup(Map<String, Object> paramMap);

	/**
	 * 靶场零故障中汇总表
	 *
	 * @param paramMap 参数
	 */
	List<Map<String, Object>> getZeroFailureByHospital(Map<String, Object> paramMap);

	/**
	 * 获取所有飞行结果
	 * @return
	 */
	String queryAllFlightResult();

	/**
	 * 获取所有型号研制阶段
	 * @return
	 */
	String queryModelDevelopPhase();

	/**
	 * 获取
	 * @return
	 */
	Integer getFlightResultCount(QueryFilter queryFilter);

	List<WQbdFlightTest> queryShowList(QueryFilter queryFilter);

	Integer querySuccessFlight(QueryFilter queryFilter);

	String getPercentageByYearAndFlight(QueryFilter queryFilter);

	double queryPercentageByYearAndName(@Param("name")String name,@Param("year")String year);

    WQbdFlightTest getParentAndChilden(String id);

    String getFlightResultMaxSecret(QueryFilter queryFilter);

    String getSuccessFlightResultMaxSecret(QueryFilter queryFilter);
}
